﻿CREATE TABLE [dbo].[Activity] (
    [Id]                INT            IDENTITY (1, 1) NOT NULL,
    [UserId]            INT            NOT NULL,
    [TransactionDate]   DATETIME       NOT NULL,
    [TransactionString] NVARCHAR (100) NOT NULL,
    [IP]                NVARCHAR (50)  NULL,
    [MacAddress]        NVARCHAR (50)  NULL,
    [AssociatedFile]    NVARCHAR (50)  NULL,
    CONSTRAINT [PK_Activity] PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [FK_Activity_User] FOREIGN KEY ([UserId]) REFERENCES [dbo].[User] ([Id])
);

